package com.haust.mapper;

import com.haust.pojo.TbItemDesc;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ItemDescMapper {

    @Select("SELECT des.item_id,des.item_desc,des.created,des.updated" +
            " FROM tb_item_desc des LEFT JOIN tb_item item on des.item_id=item.id" +
            " WHERE des.item_id=#{param1} and item.status=#{param2}")
    TbItemDesc selectOneTbItemDesc4Status1(Long id,Integer status);

}
